##! /bin/bash
#! bash
#
#  $Id: to_translator.sh 3 2010-05-27 16:25:49Z alistair.mills@btinternet.com $
#

### Main script stars here ###
# Store file name  here
export       OUTPUT=$1
export      OUTPUT2=$2
[ -f $OUTPUT  ] && rm $OUTPUT
[ -f $OUTPUT2 ] && rm $OUTPUT2
touch   $OUTPUT $OUTPUT2
export TranslatorID=0
for trans in alan alistair all any catherine chris donna lori louise richard robert ryan total unknown
do
    . ./translators.sh
    echo Adding $trans as $translator
    export TranslatorID=`expr $TranslatorID + 1`
    echo "insert into \`tblTranslator\` (\`trans\` ,   \`translator\` ) \
                                values (\"$trans\",   \"$translator\" );" >> $OUTPUT
    echo                                 "$trans;\"$translator\""         >> $OUTPUT2
done
#
#
#
